Arial
Wingdings
Monotype Sorts
Symbol
Display
Entities Entities
0 = IDEF1X, 2 = Relational
`@Set to hide the PK seperator lines in the Entities on this page.
`;Set to hide the Tabstop lines in the Entities on this page.
Use to add a table to your Object Relational diagram.
base schema.
Vis_D200.chm!#29882 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Entity
`-Identifies the shape's version to the add-on.
Set for dependent tables.
`KSet to allow free-from edits (manual edits are not maintained in the model)
`%Unique identifier used by the add-on.
`LSet if this shape's Database | Document | Options have have local overrides.
User.DBNotation `*Conditionally sets the DBNotation setting.
`5Use to add a table to your Object Relational diagram.
`FAdd,use,Relational,Database,object,your,table,Entity,diagram,ER,IDEF1X
Database Properties... DB Engineer /CMD=1001
Show Related Tables DB Engineer /CMD=1002
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
width of this shape's text
height of this shape's text
`*Subshape id within the Entity group shape.
Edit Table Name...
`*Subshape ID within the Entity group shape.
`9specifies the number of columns in the tables primary key
`HSet to hide the horizontal line seperating the PK columns from the rest.
`&Set to hide the 1st vertical tab line.
`&Set to hide the 2nd vertical tab line.
`*Indicates the number of lines in the text.
`&Indicates the height of one text line.
Edit Column Text...
Show Lines User.DBHidePKSeperatorLine User.DBHideTabLine1 User.DBHideTabLine2
0 = IDEF1X; 2 = Relational
`SOverrides the relationship notation specifed by the IDEF1X or Relational notations.
`)Set to hide all relationships on the page
Set to hide relationship text.
`*Set to hide PK, FK, and Index annotations.
`'Set to hide the PK section of Entities.
`.Set to hide the Datatype section for Entities.
`\Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
`jSet to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Relationships Relationships
Use to define a foreign key between two tables in your Object Relational diagram.
Vis_D200.chm!#29885 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Relationships
IDEF1X Notation
Crow's Foot Notation
Relational Notation
Relationship (Foreign Key)
`BSet to indicate the relationship is an 'Identifying Relationship'.
`C25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
`-Set to indicate the relationship is optional.
`RSet to override Database | Document | Options locally for this relationship shape.
`NSet to allow free-form editing (manual edits are not maintained in the model.)
User.DBNotation `7This formula conditionally sets the DBNotation setting.
`3Calculates a reference point for Relationship text.
User.CrowsFoot `<This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
`"reference to associated text shape
`QUse to define a foreign key between two tables in your Object Relational diagram.
`huse,two,key,between,Relational,Database,define,object,your,Relationship,diagram,ER,IDEF1X,foreign,tables
Q(-DT Q(-DT Add text here.
`'Locate referencial integrity text here.
Locate cardinality text here.
Relational Notation User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation User.CrowsFoot User.Override
Use to add a view to your Object Relational diagram.
se schema.
Vis_D200.chm!#29889 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
View
`1Set for dependent tables (doesnt apply to views).
`4Use to add a view to your Object Relational diagram.
`>Add,View,use,Relational,Database,object,your,diagram,ER,IDEF1X
Edit View Name...
Categories Categories
Use to connect a parent table to a category in your Object Relational diagram.
table.
Vis_D200.chm!#29884 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Categories
Parent Category Connector
`LSet to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
`NUse to connect a parent table to a category in your Object Relational diagram.
`Suse,Relational,Database,Category,connect,object,your,table,diagram,ER,IDEF1X,Parent
`$Set to hide category discriminators.
Use to specify that one or more tables are categories in another table in your Object Relational diagram.
Vis_D200.chm!#29879 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Edit Discriminator
Complete Category
Show Discriminator
Show Discriminator User.DBHideDiscriminator User.Override
Complete Category User.DBComplete
Category
0 = IDEF1x, 2 = Relational
`ISet to allow free-form edits (manual edits are not managed by the model.)
`.Set to indicate that the category is complete.
`"Set to hide the discriminator text
`ESet to override Databaes | Document | Options locally for this shape.
User.DBHideDiscriminator `=This formula conditionally sets the DBHideDiscriminator flag.
`(Unique id used internally by the add-on.
Shape's version number
`iUse to specify that one or more tables are categories in another table in your Object Relational diagram.
`ouse,more,One,Relational,Database,Category,object,another,your,specify,table,diagram,ER,IDEF1X,tables,categories
Reposition Discriminator Text
Use to connect a category to a child table in your Object Relational diagram.
his defines the child to be a "type" of the category's parent table.
Vis_D200.chm!#29880 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Child Category Connector
`LSet to allow free-form edits (manual edits are not maintained by the model.)
Unique ID used by the add-on.
`MUse to connect a category to a child table in your Object Relational diagram.
`Ruse,child,Relational,Database,Category,connect,object,your,table,diagram,ER,IDEF1X
Table Inheritance Table Inheritance
Use to add a super-/sub-table relationship from a parent table to a child table in your Object Relational diagram.
the child table.
Vis_D200.chm!#29886 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Table Inheritance
`(Unique ID used internally by the add-on.
Set to hide the shape.
`rUse to add a super-/sub-table relationship from a parent table to a child table in your Object Relational diagram.
`tAdd,use,child,from,Relational,Database,object,your,table,Sub,Relationship,diagram,ER,IDEF1X,Parent,inheritance,super
`:Set to hide PK, FK, and Index annotations within Entities.
`0Set to Hide Primary Key section within Entities.
`.Set to hide Datatypes section within Entities.
`bSet to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
`bSet to hide the horizontal line that seperates the PK section from the other columns of an Entity.
Composite Types Composite Types
Use to add a composite type to your Object Relational diagram.
Composite Types
Vis_D200.chm!#29887 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Composite Type
`-Set to hide the primary key columns section .
`!Set to hide the column datatypes.
`NSet to hide the vertical lines seperating the annotation or datatype sections.
`ZSet to hide the vertical line seperating the primary key section from the columns section.
``Set to allow free form edits to the entity shape (manual edits are not maintained in the model.)
`,Set if the Entity is dependent upon another.
User.DBHideAnnotations `:This fomula conditionally sets the DBHideAnnotations flag.
User.DBHidePKRow `5This formula conditionally sets the DBHidePKRow flag.
User.DBHideTypes `5This formula conditionally sets the DBHideTypes flag.
User.DBHideVerticalLines `=This formula conditionally sets the DBHideVerticalLines flag.
User.DBHideHorizontalLine `>This formula conditionally sets the DBHideHorizontalLine flag.
`?Set if this Entity shape represents a Typed table in the model.
`>Use to add a composite type to your Object Relational diagram.
`HAdd,use,type,Relational,Database,object,your,diagram,ER,IDEF1X,composite
Show Related Types DB Engineer /CMD=1002
Table
Type
`nTRUE if DBNotation = IDEF1X, or DBShapeType = View, or DBHideVerticalLines = TRUE, or DBHideAnnotations = TRUE
`9TRUE if DBHideTypes = TRUE, or DBHideVerticleLines = TRUE
`QTRUE if DBHideHorizontalLine = TRUE, or DBHidePKRow = TRUE, or DBShapeType = View
7 - Types
`HTRUE if DBHideTypes = TRUE, or DBHidePKRow = TRUE, or DBShapeType = View
6 - PKTypes
Char.Style
`OTRUE if DBHideAnnotations = TRUE, or DBNotation = IDEF1X, or DBShapeType = View
4 - Annotations
`eTRUE if DBHideAnnotations =TRUE, or DBHidePKRow = TRUE, or DBShapeType = View, or DBNotation = IDEF1X
3 - PKAnnotations
2 - Columns
`4TRUE if DBHidePKRow is true or if DBShapeType = View
1 = PKColumns
5 = Name
Type Inheritance Type Inheritance
Use to add a super-/sub-type relationship from a parent type to a child type in your Object Relational diagram.
he child type.
Vis_D200.chm!#29888 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Type Inheritance
Set to Hide the shape.
`oUse to add a super-/sub-type relationship from a parent type to a child type in your Object Relational diagram.
`sAdd,use,child,type,from,Relational,Database,object,your,Sub,Relationship,diagram,ER,IDEF1X,Parent,inheritance,super
Connector Connector
Use to connect processes in your Object Relational diagram.
press Ctrl to glue shape-to-shape.
methods.
ods.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D200.chm!#29881
`;Use to connect processes in your Object Relational diagram.
`Yuse,Connector,Dynamic,Relational,Database,connect,object,your,processes,diagram,ER,IDEF1X
Guide
TheDoc
Page-1
Gesture Format
DBNotation
DBHideHorizontalLine
DBHideVerticalLines
DBShapeType
DBShapeVersion
DBDependent
ManualEdits
RefShapeGuid
Override
OverrideDBNotation
visDescription
visKeywords
visVersion
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Connector
Relationship
DBCrowsFoot
DBHideRelationships
DBHideRelationshipText
DBHideAnnotations
DBHidePKRow
DBHideTypes
Identifying
DBCardinality
CrowsFoot
Optional
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
Parent to category
DBHideDiscriminator
DBComplete
OverrideDBHideDescriminator
Parent
Child
Category to child
Table inheritance
Hide
LockMove
OverrideDBHideAnnotations
OverrideDBHidePKRow
OverrideDBHideTypes
OverrideDBHideVerticalLines
OverrideDBHideHorizontalLine
TypedTable
PKRowHeight
NonKeyRowHeight
AnnotationColWidth
ColumnColWidth
TypeColWidth
PKStyle
NameStyle
Type inheritance
Dynamic connector